﻿namespace etracks.Helpers
{
    using System;
    using System.Collections.Generic;
    using System.Data;
    using System.Data.Common;
    using System.Linq;
    using System.Text;
    using System.Threading.Tasks;

    public interface IDatabaseHelper
    {
        string ConnectionString { get; set; }

        DbConnection Connection { get; set; }

        DbParameter GetParameter(string parameterName, object parameterValue);

        DataSet GetDataSet(string functionName, List<DbParameter> parametersList);

        void Execute(string functionName, List<DbParameter> parametersList);

        //DbConnection GetConnection();
        //DbCommand GetCommand();
        //DbDataAdapter GetDataAdapter();
        //DbDataReader GetDataReader();

    } // public interface IDatabaseHelper

} // namespace etracks.Helpers